GrapeCity.Xaml.CalcEngine
Evaluate(Object[]) Method


GrapeCity.CalcEngine.Functions Namespace > CalcAverageIfFunction Class > Evaluate Method : Evaluate(Object[]) Method

The args contains 2 - 3 items: range, criteria, [average_range].

Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.

Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.

[Average_range] is the actual set of cells to average. If omitted, range is used.

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object
'Usage
 
Dim instance As CalcAverageIfFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)
public override object Evaluate( 
   object[] args
)

Parameters

args

The args contains 2 - 3 items: range, criteria, [average_range].

Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.

Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.

[Average_range] is the actual set of cells to average. If omitted, range is used.

Return Value

A System.Object value that indicates the evaluate result.
See Also

Reference

CalcAverageIfFunction Class
CalcAverageIfFunction Members
Overload List